package com.hz.house.dao;

import com.hz.house.bean.entity.LocalTradeInfoBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;


@Mapper
public interface LocalHouseTradeHistoryMapper {
    @Select("SELECT id, area_id areaId, bs_total_area bsTotalArea,bs_home_count bsHomeCount, bs_home_area bsHomeArea, bs_other_area bsOtherArea,old_total_area oldTotalArea, old_home_count oldHomeCount, old_home_area oldHomeArea, old_other_area oldOtherArea, update_date updateDate FROM qb_house_local_trade_history WHERE TO_DAYS(update_date)=(SELECT MAX(TO_DAYS(update_date)) FROM qb_house_city_trade_history)")
    List<LocalTradeInfoBean> listNestTradeInfo();
}
